﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Web;

/// <summary>
/// Summary description for DAL_BenhVien
/// </summary>
public class DAL_BenhVien : SqlConnectionRun
{
	public DAL_BenhVien()
	{
		//
		// TODO: Add constructor logic here
		//
	}

    public BenhVien LayThongTinBenhVien()
    {
        BenhVien bv = new BenhVien();
        string sql = "SELECT TOP 1 * FROM HanhChanhBV..ThongTinBenhVien";
        DataTable dt = SqlExecuteQueryReader(sql);
        foreach(DataRow row in dt.Rows)
        {
            bv.TenBV = Factory.emptyNull(row["tenbv"]);
        }
        return bv;
    }
}